<?php
class Admin_Model_News extends Zend_Db_Table_Abstract
{
    /**
        * Model Games
        * @author Nguyen Manh Hung
        */

    protected $_name = TABLE_NEWS; 
    protected $_id = 'id';

    public function listNews(){
        $select = $this->select(Zend_Db_Table::SELECT_WITH_FROM_PART);
        $select->setIntegrityCheck(false)
        ->joinInner(TABLE_MEMBERS, TABLE_MEMBERS.'.id = '.$this->_name.'.user_id',array('first_name', 'last_name')); 
        $rows = $this->fetchAll($select);
        $rows = $rows->toArray();
        return $rows;
    }
    
    
}
